package com.swj.reggie.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.swj.reggie.common.CustomException;
import com.swj.reggie.dto.SetmealDto;
import com.swj.reggie.entity.Setmeal;
import com.swj.reggie.entity.SetmealDish;
import com.swj.reggie.mapper.SetmealMapper;
import com.swj.reggie.service.SetmealDishService;
import com.swj.reggie.service.SetmealService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.stream.Collectors;

@Service
@Slf4j
public class SetmealServiceImpl extends ServiceImpl<SetmealMapper,Setmeal> implements SetmealService {
    @Autowired
    private SetmealDishService setmealDishService;
    @Autowired
    private SetmealService setmealService;


    /**
     * 新增套餐，同时需要保存套餐和菜品的关联关系
     *      setmealDto的属性之一："setmealDishes":[{ "copies":1,"dishId":"1413385247889891330","name":"米饭","price":200},
     *      套餐setmealId=null                      "copies":1,"dishId":"1397851099502260226","name":"全家福","price":11800}]
     * @param setmealDto
     */
    @Transactional
    public void saveWithDish(SetmealDto setmealDto) {
        //保存套餐的基本信息，操作setmeal，执行insert操作
        this.save(setmealDto);

        List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();    // 一堆dishId，没有对应的setmealId
        setmealDishes.stream().map((item) -> {
            item.setSetmealId(setmealDto.getId());  // 每一行数据都加上 套餐setmealId，批量保存到关系表中
            return item;
        }).collect(Collectors.toList());

        //保存套餐和菜品的关联信息，操作setmeal_dish,执行insert操作
        setmealDishService.saveBatch(setmealDishes);
    }

    /**
     * 删除套餐，同时需要删除套餐和菜品的关联数据
     * @param ids
     */
    @Transactional
    public void removeWithDish(List<Long> ids) {
        //select count(*) from setmeal where id in (1,2,3) and status = 1
        //查询套餐状态，确定是否可用删除
        LambdaQueryWrapper<Setmeal> queryWrapper = new LambdaQueryWrapper();
        queryWrapper.in(Setmeal::getId,ids);
        queryWrapper.eq(Setmeal::getStatus,1);

        int count = this.count(queryWrapper);
        if(count > 0){
            //如果不能删除，抛出一个业务异常
            throw new CustomException("套餐正在售卖中，不能删除");
        }
        //如果可以删除，先删除套餐表中的数据---setmeal
        this.removeByIds(ids);

        //delete from setmeal_dish where setmeal_id in (1,2,3)
        LambdaQueryWrapper<SetmealDish> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.in(SetmealDish::getSetmealId,ids);   // where setmeal_id in ids
        //删除关系表中的数据----setmeal_dish
        setmealDishService.remove(lambdaQueryWrapper);
    }

    /**
     * 根据id查询套餐和对应的菜品信息，修改套餐时 回显数据
     * @param id
     * @return setmealDto   setmealDto=setmeal+setmealDishes
     */
    public SetmealDto getByIdWithDish(Long id) {
        // 根据id拿到setmeal套餐信息
        Setmeal setmeal = setmealService.getById(id);

        // 根据id拿到setmealDishes对应的菜品信息，setmeal_dish
        LambdaQueryWrapper<SetmealDish> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SetmealDish::getSetmealId,id);
        List<SetmealDish> setmealDishes = setmealDishService.list(queryWrapper);

        // 封装结果，setmealDto = setmeal + setmealDishes
        SetmealDto setmealDto = new SetmealDto();
        BeanUtils.copyProperties(setmeal,setmealDto);
        setmealDto.setSetmealDishes(setmealDishes);

        return setmealDto;
    }


    /**
     * 更新套餐信息，同时更新对应的菜品信息，update
     * @param setmealDto    setmealDto拆分成setmeal、setmealDishes，分别修改保存
     */
    @Transactional
    public void updateWithDish(SetmealDto setmealDto) {
        // 修改套餐信息，setmeal
        setmealService.updateById(setmealDto);

        // 修改对应的菜品信息，setmealDishes
        // 1. 根据套餐id删除关系表的菜品数据
        LambdaQueryWrapper<SetmealDish> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SetmealDish::getSetmealId,setmealDto.getId());
        setmealDishService.remove(queryWrapper);    // delete from setmeal_dish where sermealId = ?
        // 2. 更新关系表，存入新的套餐_菜品数据
        List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();
        setmealDishes = setmealDishes.stream().map(setmealDish -> {
            setmealDish.setSetmealId(setmealDto.getId());   // 套餐setmealId加入到每行菜品dish数据中
            return setmealDish;
        }).collect(Collectors.toList());
        // saveBatch()批量保存
        setmealDishService.saveBatch(setmealDishes);
    }
}
